package com.lsm.app.service;

import java.util.List;
import java.util.Map;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;

@Service
public class TestService {
	@Autowired
	private JdbcTemplate jdbcTemplate;
	public  List test(String grade){
//		em.query(sql, rse)
		List rows=jdbcTemplate.queryForList("SELECT XJH,NAME FROM XJ_STUDENTS WHERE  SCHOOL=? AND GRADE=?","F9DAF750A9F4484492285C948CE0A73F",grade);
		 return rows;
	}
}
